﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="ChangeStudentMajor.aspx.vb" Inherits="DARSClients.ChangeStudentMajor" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Beyond DARS - Change Major</title>
    <link id="myCSS" href="Styles/myStyle.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
        .style5
        {
            width: 159px;
        }
        .style7
        {
            width: 612px;
        }
        .style11
        {
            width: 518px;
        }
        .style13
        {
            width: 611px;
        }
    </style>
    </head>
<body>
 <div class="container">

        <div class="title-nav">

            <h2>Change Major Request <br /><h1>To request a change of major, please complete the form below!</h1></h2>

        </div>

        <div class="newLine"></div>

        <div class="content">

            <p>
            <form id="form1" runat="server">

                <table align="center">
                    
                    <tr>

                        <td>
                            <asp:GridView 
                                    ID="gvMajors" runat="server" 
                                    style="text-align: center" AutoGenerateColumns="False" 
                                    DataKeyNames="MajorID" DataSourceID="SqlDataSource2">
                                <Columns>
                                    <asp:BoundField DataField="MajorTitle" HeaderText="MajorTitle" 
                                        SortExpression="MajorTitle" />
                                    <asp:BoundField DataField="MajorID" HeaderText="MajorID" ReadOnly="True" 
                                        SortExpression="MajorID" />
                                </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:FA11_4296_BeyondDARSConnectionString %>" 
                                SelectCommand="SELECT DISTINCT [MajorTitle], [MajorID] FROM [Major] ORDER BY [MajorTitle]">
                            </asp:SqlDataSource>
                        </td>

                        <td>
                            <asp:Label ID="lblNewMajor" runat="server" Text="New Major:"></asp:Label>
                        </td>

                        <td style="text-align: center">
                            <asp:DropDownList ID="ddlMajors" runat="server" 
                                style="text-align: center; margin-bottom: 0px">
                            </asp:DropDownList>
                            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:FA11_4296_BeyondDARSConnectionString %>" 
                                
                                SelectCommand="SELECT [MajorID] FROM [Major]">
                            </asp:SqlDataSource>
                        </td>

                        <td style="text-align: center" class="style5">
                            <asp:DropDownList ID="ddlDegree" runat="server" DataSourceID="SqlDataSource4" 
                                DataTextField="DegreeID" DataValueField="DegreeID">
                            </asp:DropDownList>
                            <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:FA11_4296_BeyondDARSConnectionString %>" 
                                
                                SelectCommand="SELECT DISTINCT [DegreeID] FROM [MajorDegree] ORDER BY [DegreeID]">
                            </asp:SqlDataSource>
                        </td>

                    </tr>

                    

                    <tr>

                        <td>
                            &nbsp;</td>

                        <td>
                            &nbsp;</td>

                        <td style="text-align: center">
                            <asp:Button ID="btnSubmit" runat="server" Text="Submit" CssClass="btn" />
                        </td>

                        <td style="text-align: center" class="style5">
                            &nbsp;</td>

                    </tr>

                    

                </table>

                &nbsp;&nbsp;</p>



                <asp:Panel ID="pnlConfirm" runat="server">
                    <table style="width:100%;">
                        <tr>
                            <td class="style11">
                                <strong>Your Orginal Major is:</strong></td>
                            <td class="style13">
                                <strong>Your New Major is:</strong></td>
                            <td class="style7">
                                &nbsp;</td>
                        </tr>
                        <tr>
                            <td class="style11">
                                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<asp:GridView ID="gvStudentInfo" runat="server" 
                                    AutoGenerateColumns="False" DataKeyNames="StudentID,MajorID,DegreeID" 
                                    DataSourceID="SqlDataSource3">
                                    <Columns>
                                        <asp:BoundField DataField="StudentID" HeaderText="StudentID" ReadOnly="True" 
                                            SortExpression="StudentID" />
                                        <asp:BoundField DataField="MajorID" HeaderText="MajorID" ReadOnly="True" 
                                            SortExpression="MajorID" />
                                        <asp:BoundField DataField="DegreeID" HeaderText="DegreeID" ReadOnly="True" 
                                            SortExpression="DegreeID" />
                                    </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:FA11_4296_BeyondDARSConnectionString %>" 
                                    SelectCommand="SELECT DISTINCT [StudentID], [MajorID], [DegreeID] FROM [StudentMajor] WHERE ([StudentID] = @StudentID)">
                                    <SelectParameters>
                                        <asp:SessionParameter Name="StudentID" SessionField="StudentID" Type="String" />
                                    </SelectParameters>
                                </asp:SqlDataSource>
                            </td>
                            <td class="style13">
                                </asp:sqldatasource>
                                <asp:Label ID="lblConfirmMajor" runat="server"></asp:Label>
                                <br />
                                <asp:Label ID="lblConfirmDegree" runat="server"></asp:Label>
                            </td>
                            <td class="style7">
                                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                <asp:Button ID="btnConfirm" runat="server" CssClass="btn" Text="Confirm" />
                            </td>
                        </tr>
                    </table>
                </asp:Panel>
                <asp:Panel ID="pnlNewInfo" runat="server">
                    <table style="width:100%;">
                        <tr>
                            <td width="220">
                                <strong></strong>
                            </td>
                            <td style="text-align: left">
                                <asp:Label ID="lblMessage" runat="server" Font-Bold="True"></asp:Label>
                            </td>
                            <td>
                                <strong></strong>
                            </td>
                        </tr>
                        
                    </table>
                </asp:Panel>
        </div>

    
        </div>
        <div class="footer">
        <a><input  type="submit" class="text_button" id="btnLogout" runat="server" 
                value="Logout" causesvalidation="False" />
           <input type="submit" class="text_button" id="btnhome" runat="server" 
                value="Home" causesvalidation="False" /> </a>
        </div>
            </form>




</body>
</html>
